package springboot.bigdata.demo.example.old_db;


import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StaffExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StaffExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Integer value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Integer value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Integer value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Integer value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Integer value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Integer> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Integer> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Integer value1, Integer value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Integer value1, Integer value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffNumberIsNull() {
            addCriterion("staff_number is null");
            return (Criteria) this;
        }

        public Criteria andStaffNumberIsNotNull() {
            addCriterion("staff_number is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNumberEqualTo(String value) {
            addCriterion("staff_number =", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberNotEqualTo(String value) {
            addCriterion("staff_number <>", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberGreaterThan(String value) {
            addCriterion("staff_number >", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberGreaterThanOrEqualTo(String value) {
            addCriterion("staff_number >=", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberLessThan(String value) {
            addCriterion("staff_number <", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberLessThanOrEqualTo(String value) {
            addCriterion("staff_number <=", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberLike(String value) {
            addCriterion("staff_number like", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberNotLike(String value) {
            addCriterion("staff_number not like", value, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberIn(List<String> values) {
            addCriterion("staff_number in", values, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberNotIn(List<String> values) {
            addCriterion("staff_number not in", values, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberBetween(String value1, String value2) {
            addCriterion("staff_number between", value1, value2, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNumberNotBetween(String value1, String value2) {
            addCriterion("staff_number not between", value1, value2, "staffNumber");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNull() {
            addCriterion("staff_name is null");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNotNull() {
            addCriterion("staff_name is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNameEqualTo(String value) {
            addCriterion("staff_name =", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotEqualTo(String value) {
            addCriterion("staff_name <>", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThan(String value) {
            addCriterion("staff_name >", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("staff_name >=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThan(String value) {
            addCriterion("staff_name <", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThanOrEqualTo(String value) {
            addCriterion("staff_name <=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLike(String value) {
            addCriterion("staff_name like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotLike(String value) {
            addCriterion("staff_name not like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameIn(List<String> values) {
            addCriterion("staff_name in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotIn(List<String> values) {
            addCriterion("staff_name not in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameBetween(String value1, String value2) {
            addCriterion("staff_name between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotBetween(String value1, String value2) {
            addCriterion("staff_name not between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andEducationIsNull() {
            addCriterion("education is null");
            return (Criteria) this;
        }

        public Criteria andEducationIsNotNull() {
            addCriterion("education is not null");
            return (Criteria) this;
        }

        public Criteria andEducationEqualTo(String value) {
            addCriterion("education =", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotEqualTo(String value) {
            addCriterion("education <>", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThan(String value) {
            addCriterion("education >", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThanOrEqualTo(String value) {
            addCriterion("education >=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThan(String value) {
            addCriterion("education <", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThanOrEqualTo(String value) {
            addCriterion("education <=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLike(String value) {
            addCriterion("education like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotLike(String value) {
            addCriterion("education not like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationIn(List<String> values) {
            addCriterion("education in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotIn(List<String> values) {
            addCriterion("education not in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationBetween(String value1, String value2) {
            addCriterion("education between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotBetween(String value1, String value2) {
            addCriterion("education not between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andNationIsNull() {
            addCriterion("nation is null");
            return (Criteria) this;
        }

        public Criteria andNationIsNotNull() {
            addCriterion("nation is not null");
            return (Criteria) this;
        }

        public Criteria andNationEqualTo(String value) {
            addCriterion("nation =", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotEqualTo(String value) {
            addCriterion("nation <>", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThan(String value) {
            addCriterion("nation >", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThanOrEqualTo(String value) {
            addCriterion("nation >=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThan(String value) {
            addCriterion("nation <", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThanOrEqualTo(String value) {
            addCriterion("nation <=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLike(String value) {
            addCriterion("nation like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotLike(String value) {
            addCriterion("nation not like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationIn(List<String> values) {
            addCriterion("nation in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotIn(List<String> values) {
            addCriterion("nation not in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationBetween(String value1, String value2) {
            addCriterion("nation between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotBetween(String value1, String value2) {
            addCriterion("nation not between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andCardidIsNull() {
            addCriterion("cardid is null");
            return (Criteria) this;
        }

        public Criteria andCardidIsNotNull() {
            addCriterion("cardid is not null");
            return (Criteria) this;
        }

        public Criteria andCardidEqualTo(String value) {
            addCriterion("cardid =", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotEqualTo(String value) {
            addCriterion("cardid <>", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidGreaterThan(String value) {
            addCriterion("cardid >", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidGreaterThanOrEqualTo(String value) {
            addCriterion("cardid >=", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidLessThan(String value) {
            addCriterion("cardid <", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidLessThanOrEqualTo(String value) {
            addCriterion("cardid <=", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidLike(String value) {
            addCriterion("cardid like", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotLike(String value) {
            addCriterion("cardid not like", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidIn(List<String> values) {
            addCriterion("cardid in", values, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotIn(List<String> values) {
            addCriterion("cardid not in", values, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidBetween(String value1, String value2) {
            addCriterion("cardid between", value1, value2, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotBetween(String value1, String value2) {
            addCriterion("cardid not between", value1, value2, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceIsNull() {
            addCriterion("cardid_police is null");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceIsNotNull() {
            addCriterion("cardid_police is not null");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceEqualTo(String value) {
            addCriterion("cardid_police =", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceNotEqualTo(String value) {
            addCriterion("cardid_police <>", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceGreaterThan(String value) {
            addCriterion("cardid_police >", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceGreaterThanOrEqualTo(String value) {
            addCriterion("cardid_police >=", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceLessThan(String value) {
            addCriterion("cardid_police <", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceLessThanOrEqualTo(String value) {
            addCriterion("cardid_police <=", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceLike(String value) {
            addCriterion("cardid_police like", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceNotLike(String value) {
            addCriterion("cardid_police not like", value, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceIn(List<String> values) {
            addCriterion("cardid_police in", values, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceNotIn(List<String> values) {
            addCriterion("cardid_police not in", values, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceBetween(String value1, String value2) {
            addCriterion("cardid_police between", value1, value2, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andCardidPoliceNotBetween(String value1, String value2) {
            addCriterion("cardid_police not between", value1, value2, "cardidPolice");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNull() {
            addCriterion("birthday is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNotNull() {
            addCriterion("birthday is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayEqualTo(Date value) {
            addCriterion("birthday =", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotEqualTo(Date value) {
            addCriterion("birthday <>", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThan(Date value) {
            addCriterion("birthday >", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThanOrEqualTo(Date value) {
            addCriterion("birthday >=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThan(Date value) {
            addCriterion("birthday <", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThanOrEqualTo(Date value) {
            addCriterion("birthday <=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayIn(List<Date> values) {
            addCriterion("birthday in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotIn(List<Date> values) {
            addCriterion("birthday not in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayBetween(Date value1, Date value2) {
            addCriterion("birthday between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotBetween(Date value1, Date value2) {
            addCriterion("birthday not between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andAreaIsNull() {
            addCriterion("area is null");
            return (Criteria) this;
        }

        public Criteria andAreaIsNotNull() {
            addCriterion("area is not null");
            return (Criteria) this;
        }

        public Criteria andAreaEqualTo(String value) {
            addCriterion("area =", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotEqualTo(String value) {
            addCriterion("area <>", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThan(String value) {
            addCriterion("area >", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThanOrEqualTo(String value) {
            addCriterion("area >=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThan(String value) {
            addCriterion("area <", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThanOrEqualTo(String value) {
            addCriterion("area <=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLike(String value) {
            addCriterion("area like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotLike(String value) {
            addCriterion("area not like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaIn(List<String> values) {
            addCriterion("area in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotIn(List<String> values) {
            addCriterion("area not in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaBetween(String value1, String value2) {
            addCriterion("area between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotBetween(String value1, String value2) {
            addCriterion("area not between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andIdentityIsNull() {
            addCriterion("`identity` is null");
            return (Criteria) this;
        }

        public Criteria andIdentityIsNotNull() {
            addCriterion("`identity` is not null");
            return (Criteria) this;
        }

        public Criteria andIdentityEqualTo(String value) {
            addCriterion("`identity` =", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityNotEqualTo(String value) {
            addCriterion("`identity` <>", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityGreaterThan(String value) {
            addCriterion("`identity` >", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityGreaterThanOrEqualTo(String value) {
            addCriterion("`identity` >=", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityLessThan(String value) {
            addCriterion("`identity` <", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityLessThanOrEqualTo(String value) {
            addCriterion("`identity` <=", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityLike(String value) {
            addCriterion("`identity` like", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityNotLike(String value) {
            addCriterion("`identity` not like", value, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityIn(List<String> values) {
            addCriterion("`identity` in", values, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityNotIn(List<String> values) {
            addCriterion("`identity` not in", values, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityBetween(String value1, String value2) {
            addCriterion("`identity` between", value1, value2, "identity");
            return (Criteria) this;
        }

        public Criteria andIdentityNotBetween(String value1, String value2) {
            addCriterion("`identity` not between", value1, value2, "identity");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(Integer value) {
            addCriterion("sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(Integer value) {
            addCriterion("sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(Integer value) {
            addCriterion("sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(Integer value) {
            addCriterion("sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(Integer value) {
            addCriterion("sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<Integer> values) {
            addCriterion("sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<Integer> values) {
            addCriterion("sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(Integer value1, Integer value2) {
            addCriterion("sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(Integer value1, Integer value2) {
            addCriterion("sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusIsNull() {
            addCriterion("political_status is null");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusIsNotNull() {
            addCriterion("political_status is not null");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusEqualTo(String value) {
            addCriterion("political_status =", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusNotEqualTo(String value) {
            addCriterion("political_status <>", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusGreaterThan(String value) {
            addCriterion("political_status >", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusGreaterThanOrEqualTo(String value) {
            addCriterion("political_status >=", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusLessThan(String value) {
            addCriterion("political_status <", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusLessThanOrEqualTo(String value) {
            addCriterion("political_status <=", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusLike(String value) {
            addCriterion("political_status like", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusNotLike(String value) {
            addCriterion("political_status not like", value, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusIn(List<String> values) {
            addCriterion("political_status in", values, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusNotIn(List<String> values) {
            addCriterion("political_status not in", values, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusBetween(String value1, String value2) {
            addCriterion("political_status between", value1, value2, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andPoliticalStatusNotBetween(String value1, String value2) {
            addCriterion("political_status not between", value1, value2, "politicalStatus");
            return (Criteria) this;
        }

        public Criteria andNativePlaceIsNull() {
            addCriterion("native_place is null");
            return (Criteria) this;
        }

        public Criteria andNativePlaceIsNotNull() {
            addCriterion("native_place is not null");
            return (Criteria) this;
        }

        public Criteria andNativePlaceEqualTo(String value) {
            addCriterion("native_place =", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceNotEqualTo(String value) {
            addCriterion("native_place <>", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceGreaterThan(String value) {
            addCriterion("native_place >", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceGreaterThanOrEqualTo(String value) {
            addCriterion("native_place >=", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceLessThan(String value) {
            addCriterion("native_place <", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceLessThanOrEqualTo(String value) {
            addCriterion("native_place <=", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceLike(String value) {
            addCriterion("native_place like", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceNotLike(String value) {
            addCriterion("native_place not like", value, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceIn(List<String> values) {
            addCriterion("native_place in", values, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceNotIn(List<String> values) {
            addCriterion("native_place not in", values, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceBetween(String value1, String value2) {
            addCriterion("native_place between", value1, value2, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andNativePlaceNotBetween(String value1, String value2) {
            addCriterion("native_place not between", value1, value2, "nativePlace");
            return (Criteria) this;
        }

        public Criteria andStoreIdIsNull() {
            addCriterion("store_id is null");
            return (Criteria) this;
        }

        public Criteria andStoreIdIsNotNull() {
            addCriterion("store_id is not null");
            return (Criteria) this;
        }

        public Criteria andStoreIdEqualTo(Integer value) {
            addCriterion("store_id =", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotEqualTo(Integer value) {
            addCriterion("store_id <>", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThan(Integer value) {
            addCriterion("store_id >", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("store_id >=", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThan(Integer value) {
            addCriterion("store_id <", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThanOrEqualTo(Integer value) {
            addCriterion("store_id <=", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdIn(List<Integer> values) {
            addCriterion("store_id in", values, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotIn(List<Integer> values) {
            addCriterion("store_id not in", values, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdBetween(Integer value1, Integer value2) {
            addCriterion("store_id between", value1, value2, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotBetween(Integer value1, Integer value2) {
            addCriterion("store_id not between", value1, value2, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreTypeIsNull() {
            addCriterion("store_type is null");
            return (Criteria) this;
        }

        public Criteria andStoreTypeIsNotNull() {
            addCriterion("store_type is not null");
            return (Criteria) this;
        }

        public Criteria andStoreTypeEqualTo(String value) {
            addCriterion("store_type =", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeNotEqualTo(String value) {
            addCriterion("store_type <>", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeGreaterThan(String value) {
            addCriterion("store_type >", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeGreaterThanOrEqualTo(String value) {
            addCriterion("store_type >=", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeLessThan(String value) {
            addCriterion("store_type <", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeLessThanOrEqualTo(String value) {
            addCriterion("store_type <=", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeLike(String value) {
            addCriterion("store_type like", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeNotLike(String value) {
            addCriterion("store_type not like", value, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeIn(List<String> values) {
            addCriterion("store_type in", values, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeNotIn(List<String> values) {
            addCriterion("store_type not in", values, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeBetween(String value1, String value2) {
            addCriterion("store_type between", value1, value2, "storeType");
            return (Criteria) this;
        }

        public Criteria andStoreTypeNotBetween(String value1, String value2) {
            addCriterion("store_type not between", value1, value2, "storeType");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneIsNull() {
            addCriterion("other_phone is null");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneIsNotNull() {
            addCriterion("other_phone is not null");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneEqualTo(String value) {
            addCriterion("other_phone =", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneNotEqualTo(String value) {
            addCriterion("other_phone <>", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneGreaterThan(String value) {
            addCriterion("other_phone >", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("other_phone >=", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneLessThan(String value) {
            addCriterion("other_phone <", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneLessThanOrEqualTo(String value) {
            addCriterion("other_phone <=", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneLike(String value) {
            addCriterion("other_phone like", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneNotLike(String value) {
            addCriterion("other_phone not like", value, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneIn(List<String> values) {
            addCriterion("other_phone in", values, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneNotIn(List<String> values) {
            addCriterion("other_phone not in", values, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneBetween(String value1, String value2) {
            addCriterion("other_phone between", value1, value2, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andOtherPhoneNotBetween(String value1, String value2) {
            addCriterion("other_phone not between", value1, value2, "otherPhone");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateIsNull() {
            addCriterion("cardid_valid_date is null");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateIsNotNull() {
            addCriterion("cardid_valid_date is not null");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateEqualTo(String value) {
            addCriterion("cardid_valid_date =", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateNotEqualTo(String value) {
            addCriterion("cardid_valid_date <>", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateGreaterThan(String value) {
            addCriterion("cardid_valid_date >", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateGreaterThanOrEqualTo(String value) {
            addCriterion("cardid_valid_date >=", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateLessThan(String value) {
            addCriterion("cardid_valid_date <", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateLessThanOrEqualTo(String value) {
            addCriterion("cardid_valid_date <=", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateLike(String value) {
            addCriterion("cardid_valid_date like", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateNotLike(String value) {
            addCriterion("cardid_valid_date not like", value, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateIn(List<String> values) {
            addCriterion("cardid_valid_date in", values, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateNotIn(List<String> values) {
            addCriterion("cardid_valid_date not in", values, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateBetween(String value1, String value2) {
            addCriterion("cardid_valid_date between", value1, value2, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidDateNotBetween(String value1, String value2) {
            addCriterion("cardid_valid_date not between", value1, value2, "cardidValidDate");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionIsNull() {
            addCriterion("staff_intention is null");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionIsNotNull() {
            addCriterion("staff_intention is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionEqualTo(String value) {
            addCriterion("staff_intention =", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionNotEqualTo(String value) {
            addCriterion("staff_intention <>", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionGreaterThan(String value) {
            addCriterion("staff_intention >", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionGreaterThanOrEqualTo(String value) {
            addCriterion("staff_intention >=", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionLessThan(String value) {
            addCriterion("staff_intention <", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionLessThanOrEqualTo(String value) {
            addCriterion("staff_intention <=", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionLike(String value) {
            addCriterion("staff_intention like", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionNotLike(String value) {
            addCriterion("staff_intention not like", value, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionIn(List<String> values) {
            addCriterion("staff_intention in", values, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionNotIn(List<String> values) {
            addCriterion("staff_intention not in", values, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionBetween(String value1, String value2) {
            addCriterion("staff_intention between", value1, value2, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andStaffIntentionNotBetween(String value1, String value2) {
            addCriterion("staff_intention not between", value1, value2, "staffIntention");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddIsNull() {
            addCriterion("cardid_addredd is null");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddIsNotNull() {
            addCriterion("cardid_addredd is not null");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddEqualTo(String value) {
            addCriterion("cardid_addredd =", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddNotEqualTo(String value) {
            addCriterion("cardid_addredd <>", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddGreaterThan(String value) {
            addCriterion("cardid_addredd >", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddGreaterThanOrEqualTo(String value) {
            addCriterion("cardid_addredd >=", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddLessThan(String value) {
            addCriterion("cardid_addredd <", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddLessThanOrEqualTo(String value) {
            addCriterion("cardid_addredd <=", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddLike(String value) {
            addCriterion("cardid_addredd like", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddNotLike(String value) {
            addCriterion("cardid_addredd not like", value, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddIn(List<String> values) {
            addCriterion("cardid_addredd in", values, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddNotIn(List<String> values) {
            addCriterion("cardid_addredd not in", values, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddBetween(String value1, String value2) {
            addCriterion("cardid_addredd between", value1, value2, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andCardidAddreddNotBetween(String value1, String value2) {
            addCriterion("cardid_addredd not between", value1, value2, "cardidAddredd");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeIsNull() {
            addCriterion("is_take_office is null");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeIsNotNull() {
            addCriterion("is_take_office is not null");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeEqualTo(Integer value) {
            addCriterion("is_take_office =", value, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeNotEqualTo(Integer value) {
            addCriterion("is_take_office <>", value, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeGreaterThan(Integer value) {
            addCriterion("is_take_office >", value, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_take_office >=", value, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeLessThan(Integer value) {
            addCriterion("is_take_office <", value, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeLessThanOrEqualTo(Integer value) {
            addCriterion("is_take_office <=", value, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeIn(List<Integer> values) {
            addCriterion("is_take_office in", values, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeNotIn(List<Integer> values) {
            addCriterion("is_take_office not in", values, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeBetween(Integer value1, Integer value2) {
            addCriterion("is_take_office between", value1, value2, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeNotBetween(Integer value1, Integer value2) {
            addCriterion("is_take_office not between", value1, value2, "isTakeOffice");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andStaffStatusIsNull() {
            addCriterion("staff_status is null");
            return (Criteria) this;
        }

        public Criteria andStaffStatusIsNotNull() {
            addCriterion("staff_status is not null");
            return (Criteria) this;
        }

        public Criteria andStaffStatusEqualTo(Integer value) {
            addCriterion("staff_status =", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusNotEqualTo(Integer value) {
            addCriterion("staff_status <>", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusGreaterThan(Integer value) {
            addCriterion("staff_status >", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("staff_status >=", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusLessThan(Integer value) {
            addCriterion("staff_status <", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusLessThanOrEqualTo(Integer value) {
            addCriterion("staff_status <=", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusIn(List<Integer> values) {
            addCriterion("staff_status in", values, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusNotIn(List<Integer> values) {
            addCriterion("staff_status not in", values, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusBetween(Integer value1, Integer value2) {
            addCriterion("staff_status between", value1, value2, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("staff_status not between", value1, value2, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andHeadImgIsNull() {
            addCriterion("head_img is null");
            return (Criteria) this;
        }

        public Criteria andHeadImgIsNotNull() {
            addCriterion("head_img is not null");
            return (Criteria) this;
        }

        public Criteria andHeadImgEqualTo(String value) {
            addCriterion("head_img =", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgNotEqualTo(String value) {
            addCriterion("head_img <>", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgGreaterThan(String value) {
            addCriterion("head_img >", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgGreaterThanOrEqualTo(String value) {
            addCriterion("head_img >=", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgLessThan(String value) {
            addCriterion("head_img <", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgLessThanOrEqualTo(String value) {
            addCriterion("head_img <=", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgLike(String value) {
            addCriterion("head_img like", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgNotLike(String value) {
            addCriterion("head_img not like", value, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgIn(List<String> values) {
            addCriterion("head_img in", values, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgNotIn(List<String> values) {
            addCriterion("head_img not in", values, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgBetween(String value1, String value2) {
            addCriterion("head_img between", value1, value2, "headImg");
            return (Criteria) this;
        }

        public Criteria andHeadImgNotBetween(String value1, String value2) {
            addCriterion("head_img not between", value1, value2, "headImg");
            return (Criteria) this;
        }

        public Criteria andStaffTypeIsNull() {
            addCriterion("staff_type is null");
            return (Criteria) this;
        }

        public Criteria andStaffTypeIsNotNull() {
            addCriterion("staff_type is not null");
            return (Criteria) this;
        }

        public Criteria andStaffTypeEqualTo(Integer value) {
            addCriterion("staff_type =", value, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeNotEqualTo(Integer value) {
            addCriterion("staff_type <>", value, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeGreaterThan(Integer value) {
            addCriterion("staff_type >", value, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("staff_type >=", value, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeLessThan(Integer value) {
            addCriterion("staff_type <", value, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeLessThanOrEqualTo(Integer value) {
            addCriterion("staff_type <=", value, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeIn(List<Integer> values) {
            addCriterion("staff_type in", values, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeNotIn(List<Integer> values) {
            addCriterion("staff_type not in", values, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeBetween(Integer value1, Integer value2) {
            addCriterion("staff_type between", value1, value2, "staffType");
            return (Criteria) this;
        }

        public Criteria andStaffTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("staff_type not between", value1, value2, "staffType");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNull() {
            addCriterion("create_user_id is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNotNull() {
            addCriterion("create_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdEqualTo(Integer value) {
            addCriterion("create_user_id =", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotEqualTo(Integer value) {
            addCriterion("create_user_id <>", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThan(Integer value) {
            addCriterion("create_user_id >", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("create_user_id >=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThan(Integer value) {
            addCriterion("create_user_id <", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("create_user_id <=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIn(List<Integer> values) {
            addCriterion("create_user_id in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotIn(List<Integer> values) {
            addCriterion("create_user_id not in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdBetween(Integer value1, Integer value2) {
            addCriterion("create_user_id between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("create_user_id not between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdIsNull() {
            addCriterion("update_user_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdIsNotNull() {
            addCriterion("update_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdEqualTo(Integer value) {
            addCriterion("update_user_id =", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdNotEqualTo(Integer value) {
            addCriterion("update_user_id <>", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdGreaterThan(Integer value) {
            addCriterion("update_user_id >", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("update_user_id >=", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdLessThan(Integer value) {
            addCriterion("update_user_id <", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("update_user_id <=", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdIn(List<Integer> values) {
            addCriterion("update_user_id in", values, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdNotIn(List<Integer> values) {
            addCriterion("update_user_id not in", values, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdBetween(Integer value1, Integer value2) {
            addCriterion("update_user_id between", value1, value2, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("update_user_id not between", value1, value2, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdIsNull() {
            addCriterion("parent_store_id is null");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdIsNotNull() {
            addCriterion("parent_store_id is not null");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdEqualTo(Integer value) {
            addCriterion("parent_store_id =", value, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdNotEqualTo(Integer value) {
            addCriterion("parent_store_id <>", value, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdGreaterThan(Integer value) {
            addCriterion("parent_store_id >", value, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("parent_store_id >=", value, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdLessThan(Integer value) {
            addCriterion("parent_store_id <", value, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdLessThanOrEqualTo(Integer value) {
            addCriterion("parent_store_id <=", value, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdIn(List<Integer> values) {
            addCriterion("parent_store_id in", values, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdNotIn(List<Integer> values) {
            addCriterion("parent_store_id not in", values, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdBetween(Integer value1, Integer value2) {
            addCriterion("parent_store_id between", value1, value2, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andParentStoreIdNotBetween(Integer value1, Integer value2) {
            addCriterion("parent_store_id not between", value1, value2, "parentStoreId");
            return (Criteria) this;
        }

        public Criteria andWechatIsNull() {
            addCriterion("wechat is null");
            return (Criteria) this;
        }

        public Criteria andWechatIsNotNull() {
            addCriterion("wechat is not null");
            return (Criteria) this;
        }

        public Criteria andWechatEqualTo(String value) {
            addCriterion("wechat =", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatNotEqualTo(String value) {
            addCriterion("wechat <>", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatGreaterThan(String value) {
            addCriterion("wechat >", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatGreaterThanOrEqualTo(String value) {
            addCriterion("wechat >=", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatLessThan(String value) {
            addCriterion("wechat <", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatLessThanOrEqualTo(String value) {
            addCriterion("wechat <=", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatLike(String value) {
            addCriterion("wechat like", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatNotLike(String value) {
            addCriterion("wechat not like", value, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatIn(List<String> values) {
            addCriterion("wechat in", values, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatNotIn(List<String> values) {
            addCriterion("wechat not in", values, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatBetween(String value1, String value2) {
            addCriterion("wechat between", value1, value2, "wechat");
            return (Criteria) this;
        }

        public Criteria andWechatNotBetween(String value1, String value2) {
            addCriterion("wechat not between", value1, value2, "wechat");
            return (Criteria) this;
        }

        public Criteria andQqIsNull() {
            addCriterion("qq is null");
            return (Criteria) this;
        }

        public Criteria andQqIsNotNull() {
            addCriterion("qq is not null");
            return (Criteria) this;
        }

        public Criteria andQqEqualTo(String value) {
            addCriterion("qq =", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotEqualTo(String value) {
            addCriterion("qq <>", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThan(String value) {
            addCriterion("qq >", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThanOrEqualTo(String value) {
            addCriterion("qq >=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThan(String value) {
            addCriterion("qq <", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThanOrEqualTo(String value) {
            addCriterion("qq <=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLike(String value) {
            addCriterion("qq like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotLike(String value) {
            addCriterion("qq not like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqIn(List<String> values) {
            addCriterion("qq in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotIn(List<String> values) {
            addCriterion("qq not in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqBetween(String value1, String value2) {
            addCriterion("qq between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotBetween(String value1, String value2) {
            addCriterion("qq not between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIsNull() {
            addCriterion("social_security is null");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIsNotNull() {
            addCriterion("social_security is not null");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityEqualTo(String value) {
            addCriterion("social_security =", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityNotEqualTo(String value) {
            addCriterion("social_security <>", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityGreaterThan(String value) {
            addCriterion("social_security >", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityGreaterThanOrEqualTo(String value) {
            addCriterion("social_security >=", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityLessThan(String value) {
            addCriterion("social_security <", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityLessThanOrEqualTo(String value) {
            addCriterion("social_security <=", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityLike(String value) {
            addCriterion("social_security like", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityNotLike(String value) {
            addCriterion("social_security not like", value, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityIn(List<String> values) {
            addCriterion("social_security in", values, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityNotIn(List<String> values) {
            addCriterion("social_security not in", values, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityBetween(String value1, String value2) {
            addCriterion("social_security between", value1, value2, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityNotBetween(String value1, String value2) {
            addCriterion("social_security not between", value1, value2, "socialSecurity");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeIsNull() {
            addCriterion("social_security_type is null");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeIsNotNull() {
            addCriterion("social_security_type is not null");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeEqualTo(String value) {
            addCriterion("social_security_type =", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeNotEqualTo(String value) {
            addCriterion("social_security_type <>", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeGreaterThan(String value) {
            addCriterion("social_security_type >", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeGreaterThanOrEqualTo(String value) {
            addCriterion("social_security_type >=", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeLessThan(String value) {
            addCriterion("social_security_type <", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeLessThanOrEqualTo(String value) {
            addCriterion("social_security_type <=", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeLike(String value) {
            addCriterion("social_security_type like", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeNotLike(String value) {
            addCriterion("social_security_type not like", value, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeIn(List<String> values) {
            addCriterion("social_security_type in", values, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeNotIn(List<String> values) {
            addCriterion("social_security_type not in", values, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeBetween(String value1, String value2) {
            addCriterion("social_security_type between", value1, value2, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andSocialSecurityTypeNotBetween(String value1, String value2) {
            addCriterion("social_security_type not between", value1, value2, "socialSecurityType");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryIsNull() {
            addCriterion("clan_medical_history is null");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryIsNotNull() {
            addCriterion("clan_medical_history is not null");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryEqualTo(String value) {
            addCriterion("clan_medical_history =", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryNotEqualTo(String value) {
            addCriterion("clan_medical_history <>", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryGreaterThan(String value) {
            addCriterion("clan_medical_history >", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryGreaterThanOrEqualTo(String value) {
            addCriterion("clan_medical_history >=", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryLessThan(String value) {
            addCriterion("clan_medical_history <", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryLessThanOrEqualTo(String value) {
            addCriterion("clan_medical_history <=", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryLike(String value) {
            addCriterion("clan_medical_history like", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryNotLike(String value) {
            addCriterion("clan_medical_history not like", value, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryIn(List<String> values) {
            addCriterion("clan_medical_history in", values, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryNotIn(List<String> values) {
            addCriterion("clan_medical_history not in", values, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryBetween(String value1, String value2) {
            addCriterion("clan_medical_history between", value1, value2, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andClanMedicalHistoryNotBetween(String value1, String value2) {
            addCriterion("clan_medical_history not between", value1, value2, "clanMedicalHistory");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNull() {
            addCriterion("province_code is null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNotNull() {
            addCriterion("province_code is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeEqualTo(String value) {
            addCriterion("province_code =", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotEqualTo(String value) {
            addCriterion("province_code <>", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThan(String value) {
            addCriterion("province_code >", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("province_code >=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThan(String value) {
            addCriterion("province_code <", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThanOrEqualTo(String value) {
            addCriterion("province_code <=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLike(String value) {
            addCriterion("province_code like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotLike(String value) {
            addCriterion("province_code not like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIn(List<String> values) {
            addCriterion("province_code in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotIn(List<String> values) {
            addCriterion("province_code not in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeBetween(String value1, String value2) {
            addCriterion("province_code between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotBetween(String value1, String value2) {
            addCriterion("province_code not between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNull() {
            addCriterion("city_code is null");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNotNull() {
            addCriterion("city_code is not null");
            return (Criteria) this;
        }

        public Criteria andCityCodeEqualTo(String value) {
            addCriterion("city_code =", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotEqualTo(String value) {
            addCriterion("city_code <>", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThan(String value) {
            addCriterion("city_code >", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThanOrEqualTo(String value) {
            addCriterion("city_code >=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThan(String value) {
            addCriterion("city_code <", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThanOrEqualTo(String value) {
            addCriterion("city_code <=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLike(String value) {
            addCriterion("city_code like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotLike(String value) {
            addCriterion("city_code not like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeIn(List<String> values) {
            addCriterion("city_code in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotIn(List<String> values) {
            addCriterion("city_code not in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeBetween(String value1, String value2) {
            addCriterion("city_code between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotBetween(String value1, String value2) {
            addCriterion("city_code not between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIsNull() {
            addCriterion("area_code is null");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIsNotNull() {
            addCriterion("area_code is not null");
            return (Criteria) this;
        }

        public Criteria andAreaCodeEqualTo(String value) {
            addCriterion("area_code =", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotEqualTo(String value) {
            addCriterion("area_code <>", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeGreaterThan(String value) {
            addCriterion("area_code >", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeGreaterThanOrEqualTo(String value) {
            addCriterion("area_code >=", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeLessThan(String value) {
            addCriterion("area_code <", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeLessThanOrEqualTo(String value) {
            addCriterion("area_code <=", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeLike(String value) {
            addCriterion("area_code like", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotLike(String value) {
            addCriterion("area_code not like", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIn(List<String> values) {
            addCriterion("area_code in", values, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotIn(List<String> values) {
            addCriterion("area_code not in", values, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeBetween(String value1, String value2) {
            addCriterion("area_code between", value1, value2, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotBetween(String value1, String value2) {
            addCriterion("area_code not between", value1, value2, "areaCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeIsNull() {
            addCriterion("native_place_province_code is null");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeIsNotNull() {
            addCriterion("native_place_province_code is not null");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeEqualTo(String value) {
            addCriterion("native_place_province_code =", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeNotEqualTo(String value) {
            addCriterion("native_place_province_code <>", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeGreaterThan(String value) {
            addCriterion("native_place_province_code >", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("native_place_province_code >=", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeLessThan(String value) {
            addCriterion("native_place_province_code <", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeLessThanOrEqualTo(String value) {
            addCriterion("native_place_province_code <=", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeLike(String value) {
            addCriterion("native_place_province_code like", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeNotLike(String value) {
            addCriterion("native_place_province_code not like", value, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeIn(List<String> values) {
            addCriterion("native_place_province_code in", values, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeNotIn(List<String> values) {
            addCriterion("native_place_province_code not in", values, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeBetween(String value1, String value2) {
            addCriterion("native_place_province_code between", value1, value2, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceProvinceCodeNotBetween(String value1, String value2) {
            addCriterion("native_place_province_code not between", value1, value2, "nativePlaceProvinceCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeIsNull() {
            addCriterion("native_place_city_code is null");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeIsNotNull() {
            addCriterion("native_place_city_code is not null");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeEqualTo(String value) {
            addCriterion("native_place_city_code =", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeNotEqualTo(String value) {
            addCriterion("native_place_city_code <>", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeGreaterThan(String value) {
            addCriterion("native_place_city_code >", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeGreaterThanOrEqualTo(String value) {
            addCriterion("native_place_city_code >=", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeLessThan(String value) {
            addCriterion("native_place_city_code <", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeLessThanOrEqualTo(String value) {
            addCriterion("native_place_city_code <=", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeLike(String value) {
            addCriterion("native_place_city_code like", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeNotLike(String value) {
            addCriterion("native_place_city_code not like", value, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeIn(List<String> values) {
            addCriterion("native_place_city_code in", values, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeNotIn(List<String> values) {
            addCriterion("native_place_city_code not in", values, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeBetween(String value1, String value2) {
            addCriterion("native_place_city_code between", value1, value2, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andNativePlaceCityCodeNotBetween(String value1, String value2) {
            addCriterion("native_place_city_code not between", value1, value2, "nativePlaceCityCode");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeIsNull() {
            addCriterion("start_service_time is null");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeIsNotNull() {
            addCriterion("start_service_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeEqualTo(Date value) {
            addCriterion("start_service_time =", value, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeNotEqualTo(Date value) {
            addCriterion("start_service_time <>", value, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeGreaterThan(Date value) {
            addCriterion("start_service_time >", value, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_service_time >=", value, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeLessThan(Date value) {
            addCriterion("start_service_time <", value, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_service_time <=", value, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeIn(List<Date> values) {
            addCriterion("start_service_time in", values, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeNotIn(List<Date> values) {
            addCriterion("start_service_time not in", values, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeBetween(Date value1, Date value2) {
            addCriterion("start_service_time between", value1, value2, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andStartServiceTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_service_time not between", value1, value2, "startServiceTime");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingIsNull() {
            addCriterion("name_first_pingying is null");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingIsNotNull() {
            addCriterion("name_first_pingying is not null");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingEqualTo(String value) {
            addCriterion("name_first_pingying =", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingNotEqualTo(String value) {
            addCriterion("name_first_pingying <>", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingGreaterThan(String value) {
            addCriterion("name_first_pingying >", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingGreaterThanOrEqualTo(String value) {
            addCriterion("name_first_pingying >=", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingLessThan(String value) {
            addCriterion("name_first_pingying <", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingLessThanOrEqualTo(String value) {
            addCriterion("name_first_pingying <=", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingLike(String value) {
            addCriterion("name_first_pingying like", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingNotLike(String value) {
            addCriterion("name_first_pingying not like", value, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingIn(List<String> values) {
            addCriterion("name_first_pingying in", values, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingNotIn(List<String> values) {
            addCriterion("name_first_pingying not in", values, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingBetween(String value1, String value2) {
            addCriterion("name_first_pingying between", value1, value2, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andNameFirstPingyingNotBetween(String value1, String value2) {
            addCriterion("name_first_pingying not between", value1, value2, "nameFirstPingying");
            return (Criteria) this;
        }

        public Criteria andTechniqueIsNull() {
            addCriterion("technique is null");
            return (Criteria) this;
        }

        public Criteria andTechniqueIsNotNull() {
            addCriterion("technique is not null");
            return (Criteria) this;
        }

        public Criteria andTechniqueEqualTo(String value) {
            addCriterion("technique =", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueNotEqualTo(String value) {
            addCriterion("technique <>", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueGreaterThan(String value) {
            addCriterion("technique >", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueGreaterThanOrEqualTo(String value) {
            addCriterion("technique >=", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueLessThan(String value) {
            addCriterion("technique <", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueLessThanOrEqualTo(String value) {
            addCriterion("technique <=", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueLike(String value) {
            addCriterion("technique like", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueNotLike(String value) {
            addCriterion("technique not like", value, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueIn(List<String> values) {
            addCriterion("technique in", values, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueNotIn(List<String> values) {
            addCriterion("technique not in", values, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueBetween(String value1, String value2) {
            addCriterion("technique between", value1, value2, "technique");
            return (Criteria) this;
        }

        public Criteria andTechniqueNotBetween(String value1, String value2) {
            addCriterion("technique not between", value1, value2, "technique");
            return (Criteria) this;
        }

        public Criteria andHonourIsNull() {
            addCriterion("honour is null");
            return (Criteria) this;
        }

        public Criteria andHonourIsNotNull() {
            addCriterion("honour is not null");
            return (Criteria) this;
        }

        public Criteria andHonourEqualTo(String value) {
            addCriterion("honour =", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourNotEqualTo(String value) {
            addCriterion("honour <>", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourGreaterThan(String value) {
            addCriterion("honour >", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourGreaterThanOrEqualTo(String value) {
            addCriterion("honour >=", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourLessThan(String value) {
            addCriterion("honour <", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourLessThanOrEqualTo(String value) {
            addCriterion("honour <=", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourLike(String value) {
            addCriterion("honour like", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourNotLike(String value) {
            addCriterion("honour not like", value, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourIn(List<String> values) {
            addCriterion("honour in", values, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourNotIn(List<String> values) {
            addCriterion("honour not in", values, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourBetween(String value1, String value2) {
            addCriterion("honour between", value1, value2, "honour");
            return (Criteria) this;
        }

        public Criteria andHonourNotBetween(String value1, String value2) {
            addCriterion("honour not between", value1, value2, "honour");
            return (Criteria) this;
        }

        public Criteria andJudgeIsNull() {
            addCriterion("judge is null");
            return (Criteria) this;
        }

        public Criteria andJudgeIsNotNull() {
            addCriterion("judge is not null");
            return (Criteria) this;
        }

        public Criteria andJudgeEqualTo(String value) {
            addCriterion("judge =", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeNotEqualTo(String value) {
            addCriterion("judge <>", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeGreaterThan(String value) {
            addCriterion("judge >", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeGreaterThanOrEqualTo(String value) {
            addCriterion("judge >=", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeLessThan(String value) {
            addCriterion("judge <", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeLessThanOrEqualTo(String value) {
            addCriterion("judge <=", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeLike(String value) {
            addCriterion("judge like", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeNotLike(String value) {
            addCriterion("judge not like", value, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeIn(List<String> values) {
            addCriterion("judge in", values, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeNotIn(List<String> values) {
            addCriterion("judge not in", values, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeBetween(String value1, String value2) {
            addCriterion("judge between", value1, value2, "judge");
            return (Criteria) this;
        }

        public Criteria andJudgeNotBetween(String value1, String value2) {
            addCriterion("judge not between", value1, value2, "judge");
            return (Criteria) this;
        }

        public Criteria andArchivesExistIsNull() {
            addCriterion("archives_exist is null");
            return (Criteria) this;
        }

        public Criteria andArchivesExistIsNotNull() {
            addCriterion("archives_exist is not null");
            return (Criteria) this;
        }

        public Criteria andArchivesExistEqualTo(Integer value) {
            addCriterion("archives_exist =", value, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistNotEqualTo(Integer value) {
            addCriterion("archives_exist <>", value, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistGreaterThan(Integer value) {
            addCriterion("archives_exist >", value, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistGreaterThanOrEqualTo(Integer value) {
            addCriterion("archives_exist >=", value, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistLessThan(Integer value) {
            addCriterion("archives_exist <", value, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistLessThanOrEqualTo(Integer value) {
            addCriterion("archives_exist <=", value, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistIn(List<Integer> values) {
            addCriterion("archives_exist in", values, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistNotIn(List<Integer> values) {
            addCriterion("archives_exist not in", values, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistBetween(Integer value1, Integer value2) {
            addCriterion("archives_exist between", value1, value2, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andArchivesExistNotBetween(Integer value1, Integer value2) {
            addCriterion("archives_exist not between", value1, value2, "archivesExist");
            return (Criteria) this;
        }

        public Criteria andStoreNameIsNull() {
            addCriterion("store_name is null");
            return (Criteria) this;
        }

        public Criteria andStoreNameIsNotNull() {
            addCriterion("store_name is not null");
            return (Criteria) this;
        }

        public Criteria andStoreNameEqualTo(String value) {
            addCriterion("store_name =", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameNotEqualTo(String value) {
            addCriterion("store_name <>", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameGreaterThan(String value) {
            addCriterion("store_name >", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameGreaterThanOrEqualTo(String value) {
            addCriterion("store_name >=", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameLessThan(String value) {
            addCriterion("store_name <", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameLessThanOrEqualTo(String value) {
            addCriterion("store_name <=", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameLike(String value) {
            addCriterion("store_name like", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameNotLike(String value) {
            addCriterion("store_name not like", value, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameIn(List<String> values) {
            addCriterion("store_name in", values, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameNotIn(List<String> values) {
            addCriterion("store_name not in", values, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameBetween(String value1, String value2) {
            addCriterion("store_name between", value1, value2, "storeName");
            return (Criteria) this;
        }

        public Criteria andStoreNameNotBetween(String value1, String value2) {
            addCriterion("store_name not between", value1, value2, "storeName");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeIsNull() {
            addCriterion("dimission_time is null");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeIsNotNull() {
            addCriterion("dimission_time is not null");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeEqualTo(Date value) {
            addCriterion("dimission_time =", value, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeNotEqualTo(Date value) {
            addCriterion("dimission_time <>", value, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeGreaterThan(Date value) {
            addCriterion("dimission_time >", value, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("dimission_time >=", value, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeLessThan(Date value) {
            addCriterion("dimission_time <", value, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeLessThanOrEqualTo(Date value) {
            addCriterion("dimission_time <=", value, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeIn(List<Date> values) {
            addCriterion("dimission_time in", values, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeNotIn(List<Date> values) {
            addCriterion("dimission_time not in", values, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeBetween(Date value1, Date value2) {
            addCriterion("dimission_time between", value1, value2, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andDimissionTimeNotBetween(Date value1, Date value2) {
            addCriterion("dimission_time not between", value1, value2, "dimissionTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeIsNull() {
            addCriterion("no_work_time is null");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeIsNotNull() {
            addCriterion("no_work_time is not null");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeEqualTo(Date value) {
            addCriterion("no_work_time =", value, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeNotEqualTo(Date value) {
            addCriterion("no_work_time <>", value, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeGreaterThan(Date value) {
            addCriterion("no_work_time >", value, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("no_work_time >=", value, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeLessThan(Date value) {
            addCriterion("no_work_time <", value, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeLessThanOrEqualTo(Date value) {
            addCriterion("no_work_time <=", value, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeIn(List<Date> values) {
            addCriterion("no_work_time in", values, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeNotIn(List<Date> values) {
            addCriterion("no_work_time not in", values, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeBetween(Date value1, Date value2) {
            addCriterion("no_work_time between", value1, value2, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andNoWorkTimeNotBetween(Date value1, Date value2) {
            addCriterion("no_work_time not between", value1, value2, "noWorkTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeIsNull() {
            addCriterion("work_time is null");
            return (Criteria) this;
        }

        public Criteria andWorkTimeIsNotNull() {
            addCriterion("work_time is not null");
            return (Criteria) this;
        }

        public Criteria andWorkTimeEqualTo(Date value) {
            addCriterion("work_time =", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeNotEqualTo(Date value) {
            addCriterion("work_time <>", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeGreaterThan(Date value) {
            addCriterion("work_time >", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("work_time >=", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeLessThan(Date value) {
            addCriterion("work_time <", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeLessThanOrEqualTo(Date value) {
            addCriterion("work_time <=", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeIn(List<Date> values) {
            addCriterion("work_time in", values, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeNotIn(List<Date> values) {
            addCriterion("work_time not in", values, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeBetween(Date value1, Date value2) {
            addCriterion("work_time between", value1, value2, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeNotBetween(Date value1, Date value2) {
            addCriterion("work_time not between", value1, value2, "workTime");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceIsNull() {
            addCriterion("is_take_office_source is null");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceIsNotNull() {
            addCriterion("is_take_office_source is not null");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceEqualTo(Short value) {
            addCriterion("is_take_office_source =", value, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceNotEqualTo(Short value) {
            addCriterion("is_take_office_source <>", value, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceGreaterThan(Short value) {
            addCriterion("is_take_office_source >", value, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceGreaterThanOrEqualTo(Short value) {
            addCriterion("is_take_office_source >=", value, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceLessThan(Short value) {
            addCriterion("is_take_office_source <", value, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceLessThanOrEqualTo(Short value) {
            addCriterion("is_take_office_source <=", value, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceIn(List<Short> values) {
            addCriterion("is_take_office_source in", values, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceNotIn(List<Short> values) {
            addCriterion("is_take_office_source not in", values, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceBetween(Short value1, Short value2) {
            addCriterion("is_take_office_source between", value1, value2, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andIsTakeOfficeSourceNotBetween(Short value1, Short value2) {
            addCriterion("is_take_office_source not between", value1, value2, "isTakeOfficeSource");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateIsNull() {
            addCriterion("cardid_valid_begin_date is null");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateIsNotNull() {
            addCriterion("cardid_valid_begin_date is not null");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateEqualTo(String value) {
            addCriterion("cardid_valid_begin_date =", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateNotEqualTo(String value) {
            addCriterion("cardid_valid_begin_date <>", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateGreaterThan(String value) {
            addCriterion("cardid_valid_begin_date >", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateGreaterThanOrEqualTo(String value) {
            addCriterion("cardid_valid_begin_date >=", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateLessThan(String value) {
            addCriterion("cardid_valid_begin_date <", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateLessThanOrEqualTo(String value) {
            addCriterion("cardid_valid_begin_date <=", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateLike(String value) {
            addCriterion("cardid_valid_begin_date like", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateNotLike(String value) {
            addCriterion("cardid_valid_begin_date not like", value, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateIn(List<String> values) {
            addCriterion("cardid_valid_begin_date in", values, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateNotIn(List<String> values) {
            addCriterion("cardid_valid_begin_date not in", values, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateBetween(String value1, String value2) {
            addCriterion("cardid_valid_begin_date between", value1, value2, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidBeginDateNotBetween(String value1, String value2) {
            addCriterion("cardid_valid_begin_date not between", value1, value2, "cardidValidBeginDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateIsNull() {
            addCriterion("cardid_valid_end_date is null");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateIsNotNull() {
            addCriterion("cardid_valid_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateEqualTo(String value) {
            addCriterion("cardid_valid_end_date =", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateNotEqualTo(String value) {
            addCriterion("cardid_valid_end_date <>", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateGreaterThan(String value) {
            addCriterion("cardid_valid_end_date >", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateGreaterThanOrEqualTo(String value) {
            addCriterion("cardid_valid_end_date >=", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateLessThan(String value) {
            addCriterion("cardid_valid_end_date <", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateLessThanOrEqualTo(String value) {
            addCriterion("cardid_valid_end_date <=", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateLike(String value) {
            addCriterion("cardid_valid_end_date like", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateNotLike(String value) {
            addCriterion("cardid_valid_end_date not like", value, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateIn(List<String> values) {
            addCriterion("cardid_valid_end_date in", values, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateNotIn(List<String> values) {
            addCriterion("cardid_valid_end_date not in", values, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateBetween(String value1, String value2) {
            addCriterion("cardid_valid_end_date between", value1, value2, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidValidEndDateNotBetween(String value1, String value2) {
            addCriterion("cardid_valid_end_date not between", value1, value2, "cardidValidEndDate");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgIsNull() {
            addCriterion("cardid_positive_img is null");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgIsNotNull() {
            addCriterion("cardid_positive_img is not null");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgEqualTo(String value) {
            addCriterion("cardid_positive_img =", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgNotEqualTo(String value) {
            addCriterion("cardid_positive_img <>", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgGreaterThan(String value) {
            addCriterion("cardid_positive_img >", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgGreaterThanOrEqualTo(String value) {
            addCriterion("cardid_positive_img >=", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgLessThan(String value) {
            addCriterion("cardid_positive_img <", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgLessThanOrEqualTo(String value) {
            addCriterion("cardid_positive_img <=", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgLike(String value) {
            addCriterion("cardid_positive_img like", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgNotLike(String value) {
            addCriterion("cardid_positive_img not like", value, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgIn(List<String> values) {
            addCriterion("cardid_positive_img in", values, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgNotIn(List<String> values) {
            addCriterion("cardid_positive_img not in", values, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgBetween(String value1, String value2) {
            addCriterion("cardid_positive_img between", value1, value2, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidPositiveImgNotBetween(String value1, String value2) {
            addCriterion("cardid_positive_img not between", value1, value2, "cardidPositiveImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgIsNull() {
            addCriterion("cardid_reverse_img is null");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgIsNotNull() {
            addCriterion("cardid_reverse_img is not null");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgEqualTo(String value) {
            addCriterion("cardid_reverse_img =", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgNotEqualTo(String value) {
            addCriterion("cardid_reverse_img <>", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgGreaterThan(String value) {
            addCriterion("cardid_reverse_img >", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgGreaterThanOrEqualTo(String value) {
            addCriterion("cardid_reverse_img >=", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgLessThan(String value) {
            addCriterion("cardid_reverse_img <", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgLessThanOrEqualTo(String value) {
            addCriterion("cardid_reverse_img <=", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgLike(String value) {
            addCriterion("cardid_reverse_img like", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgNotLike(String value) {
            addCriterion("cardid_reverse_img not like", value, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgIn(List<String> values) {
            addCriterion("cardid_reverse_img in", values, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgNotIn(List<String> values) {
            addCriterion("cardid_reverse_img not in", values, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgBetween(String value1, String value2) {
            addCriterion("cardid_reverse_img between", value1, value2, "cardidReverseImg");
            return (Criteria) this;
        }

        public Criteria andCardidReverseImgNotBetween(String value1, String value2) {
            addCriterion("cardid_reverse_img not between", value1, value2, "cardidReverseImg");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}